--HEADER Add 'Html' column to DiaryEntry

ALTER TABLE [UDS].[DiaryEntry] ADD Html NVARCHAR(MAX) NULL
GO

UPDATE [UDS].[DiaryEntry]
SET Html = [Text]